-- 上线之前清理redis内所有ticket
ALTER TABLE course RENAME TO contract;
-- rename  course -> contract
-- 处理contract 课时数据 和类型数据
UPDATE contract set category = 2 WHERE name ='早教'
UPDATE contract set category = 1 WHERE name like '%托%'
-- 整理完成所有合同表contract的课程时间。执行ContractOperator内的方法
-- 处理children status字段。

-- 检查是否每个人有角色
SELECT s.id, s.realName, r.roleCode, r.roleName from staff s LEFT JOIN  rel_staff_role sr ON s.id =sr.staffId LEFT JOIN teach_role r ON sr.roleId = r.id;


-- 添加新角色
BEGIN;
INSERT INTO `teach_role` (id, comment, deleted, roleCode, roleName) VALUES
 ('4028478d5da239d4015da239e20d0000', '', b'0', 'ROLE_ADMIN', '管理员'),
 ('4028478d5da239d4015da239e2230001', '', b'0', 'ROLE_GARDEN_LEADER', '园区园长'),
 ('4028478d5da239d4015da239e2230002', '', b'0', 'ROLE_TEACHER', '园区教师'),
 ('4028478d5da239d4015da239e2230003', '', b'0', 'ROLE_DOCTOR', '园区医生');
COMMIT;

-- 初始化 宝宝扩展信息
INSERT INTO children_extend_info (id, childrenId ,childrenName) select id, id, `name` from Children;
-- 同时根据合同表处理 总课时和剩余课时


-- 初始化 宝宝进行中的课程
INSERT INTO children_course (id, childrenId) select id, id from Children;

-- 初始化 宝宝进行中的课程 没有添加宝宝进行中课程的
INSERT INTO children_course (id, childrenId) (select c.id, c.id from Children c LEFT JOIN children_course cc on c.id = cc.childrenId where cc.id is NULL);

-- 处理live_record operatorName;
-- classes 删掉type字段


-- 修改宝宝month字段 执行test->schedulerServiceTests->testModifyChildrenMonth

-- 执行ChildrenOperator ->processCode 处理children code字段


ALTER TABLE `staff` ADD COLUMN `praise`  int NOT NULL DEFAULT 0 COMMENT '赞' AFTER `username`;

--复制teaching_material_early， teaching_type_early, teaching_material_early_atta三张表
-- 替换teaching_material表数据

-- 复制evaluating, evaluating_ce, evaluating_ce_option, evaluating_game, evaluating_question, rel_evaluating_game 表数据
-- 复制 observation, observation_type, observation_option 表数据


-- 清空menu重新导入
-- ----------------------------
--  Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES
('4028478d5da2317c015da2318abd0000', b'0', 'fa fa-dashboard', '0', '0', '首页', '', '/'),
('4028478d5da2317c015da2318abd0100', b'0', 'fa fa-envelope', '0', '0', '员工管理', '', '/baby'),
('4028478d5da2317c015da2318abd0101', b'0', '', '1', '1', '员工列表', '4028478d5da2317c015da2318abd0100', '/baby/basicList'),
('4028478d5da2317c015da2318abd0102', b'0', '', '2', '1', '添加员工', '4028478d5da2317c015da2318abd0100', '/baby/basicCourseList'),
('4028478d5da2317c015da2318abd0200', b'0', 'fa-balance-scale', '0', '0', '学籍管理', '', '/evaluate'),
('4028478d5da2317c015da2318abd0201', b'0', '', '1', '1', '宝宝列表', '4028478d5da2317c015da2318abd0200', '/evaluate/entrustList'),
('4028478d5da2317c015da2318abd0202', b'0', '', '2', '1', '合同列表', '4028478d5da2317c015da2318abd0200', '/evaluate/satList'),
('4028478d5da2317c015da2318abd0203', b'0', '', '3', '1', '添加合同', '4028478d5da2317c015da2318abd0200', '/evaluate/satReport'),
('4028478d5da2317c015da2318abd0204', b'0', '', '4', '1', '教学建议', '4028478d5da2317c015da2318abd0200', ''),
('4028478d5da2317c015da2318abd0300', b'0', 'fa fa-group', '0', '0', '评测管理', '', '/classes'),
('4028478d5da2317c015da2318abd0301', b'0', '', '1', '1', '托班月评', '4028478d5da2317c015da2318abd0300', '/classes/list'),
('4028478d5da2317c015da2318abd0302', b'0', '', '2', '1', 'SAT初评', '4028478d5da2317c015da2318abd0300', '/classes/add'),
('4028478d5da2317c015da2318abd0303', b'0', '', '3', '1', 'SAT月评', '4028478d5da2317c015da2318abd0300', ''),
('4028478d5da2317c015da2318abd0304', b'0', '', '4', '1', '儿保评测', '4028478d5da2317c015da2318abd0300', ''),
('4028478d5da2317c015da2318abd0400', b'0', 'fa fa-table', '0', '0', '托班管理', '', '/teach'),
('4028478d5da2317c015da2318abd0401', b'0', '', '1', '1', '全部班级', '4028478d5da2317c015da2318abd0400', '/teach/satList'),
('4028478d5da2317c015da2318abd0402', b'0', '', '2', '1', '我的班级', '4028478d5da2317c015da2318abd0400', ''),
('4028478d5da2317c015da2318abd0403', b'0', '', '3', '1', '添加班级', '4028478d5da2317c015da2318abd0400', ''),
('4028478d5da2317c015da2318abd0404', b'0', '', '4', '1', '托班宝宝管理', '4028478d5da2317c015da2318abd0400', ''),
('4028478d5da2317c015da2318abd0500', b'0', 'fa fa-video-camera', '0', '0', 'SAT早教管理', '', '/camera'),
('4028478d5da2317c015da2318abd0501', b'0', '', '1', '1', 'SAT排课', '4028478d5da2317c015da2318abd0500', '/camera/local'),
('4028478d5da2317c015da2318abd0502', b'0', '', '2', '1', 'SAT宝宝管理', '4028478d5da2317c015da2318abd0500', '/camera/all'),
('4028478d5da2317c015da2318abd0503', b'0', '', '3', '1', '我的SAT课表', '4028478d5da2317c015da2318abd0500', ''),
('4028478d5da2317c015da2318abd0504', b'0', '', '4', '1', '全园SAT课表', '4028478d5da2317c015da2318abd0500', ''),
('4028478d5da2317c015da2318abd0600', b'0', '', '0', '0', '课程管理', '', ''),
('4028478d5da2317c015da2318abd0601', b'0', '', '1', '1', '园区自建课程', '4028478d5da2317c015da2318abd0600', ''),
('4028478d5da2317c015da2318abd0602', b'0', '', '2', '1', '新建自建课程', '4028478d5da2317c015da2318abd0600', ''),
('4028478d5da2317c015da2318abd0603', b'0', '', '3', '1', '托班成长方案查询', '4028478d5da2317c015da2318abd0600', ''),
('4028478d5da2317c015da2318abd0604', b'0', '', '4', '1', 'SAT课程查询', '4028478d5da2317c015da2318abd0600', ''),
('4028478d5da2317c015da2318abd0700', b'0', '', '0', '0', '物资管理', '', ''),
('4028478d5da2317c015da2318abd0701', b'0', '', '1', '1', '物资概况', '4028478d5da2317c015da2318abd0700', ''),
('4028478d5da2317c015da2318abd0702', b'0', '', '2', '1', '物资录入', '4028478d5da2317c015da2318abd0700', ''),
('4028478d5da2317c015da2318abd0703', b'0', '', '3', '1', '物资借出记录', '4028478d5da2317c015da2318abd0700', ''),
('4028478d5da2317c015da2318abd0704', b'0', '', '4', '1', '物资归还记录', '4028478d5da2317c015da2318abd0700', ''),
('4028478d5da2317c015da2318abd0800', b'0', '', '0', '0', '园区基础数据', '', ''),
('4028478d5da2317c015da2318abd0801', b'0', '', '1', '1', '摄像头管理', '4028478d5da2317c015da2318abd0800', ''),
('4028478d5da2317c015da2318abd0802', b'0', '', '2', '1', '教学区域管理', '4028478d5da2317c015da2318abd0800', ''),
('4028478d5da2317c015da2318abd0900', b'0', '', '0', '0', '会议管理', '', ''),
('4028478d5da2317c015da2318abd0901', b'0', '', '1', '1', '会议列表', '4028478d5da2317c015da2318abd0900', ''),
('4028478d5da2317c015da2318abd0902', b'0', '', '2', '1', '新建会议', '4028478d5da2317c015da2318abd0900', ''),
('4028478d5da2317c015da2318abd1000', b'0', '', '0', '0', '权限管理', '', ''),
('4028478d5da2317c015da2318abd1001', b'0', '', '1', '1', '角色分配', '4028478d5da2317c015da2318abd1000', ''),
('4028478d5da2317c015da2318abd1002', b'0', '', '2', '1', '更换园区', '4028478d5da2317c015da2318abd1000', ''),
('4028478d5da2317c015da2318abd1100', b'0', '', '0', '0', '系统基础数据', '', ''),
('4028478d5da2317c015da2318abd1101', b'0', '', '1', '1', '全园区摄像头', '4028478d5da2317c015da2318abd1100', ''),
('4028478d5da2317c015da2318abd1102', b'0', '', '2', '1', '常用下载', '4028478d5da2317c015da2318abd1100', ''),
('4028478d5da2317c015da2318abd1103', b'0', '', '3', '1', 'SAT附录', '4028478d5da2317c015da2318abd1100', '');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

-- 清空rel_role_menu重新导入
-- ----------------------------
--  Records of `rel_role_menu`
-- ----------------------------
BEGIN;
INSERT INTO `rel_role_menu` VALUES
('7fe81ea7835041fd9a6f6b7d83ec8000', '4028478d5da2317c015da2318abd0000', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8001', '4028478d5da2317c015da2318abd0100', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8002', '4028478d5da2317c015da2318abd0101', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8003', '4028478d5da2317c015da2318abd0102', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8004', '4028478d5da2317c015da2318abd0200', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8005', '4028478d5da2317c015da2318abd0201', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8006', '4028478d5da2317c015da2318abd0202', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8007', '4028478d5da2317c015da2318abd0203', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8008', '4028478d5da2317c015da2318abd0204', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8009', '4028478d5da2317c015da2318abd0300', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8010', '4028478d5da2317c015da2318abd0301', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8011', '4028478d5da2317c015da2318abd0302', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8012', '4028478d5da2317c015da2318abd0303', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8013', '4028478d5da2317c015da2318abd0304', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8014', '4028478d5da2317c015da2318abd0400', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8015', '4028478d5da2317c015da2318abd0401', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8016', '4028478d5da2317c015da2318abd0402', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8017', '4028478d5da2317c015da2318abd0403', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8018', '4028478d5da2317c015da2318abd0404', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8019', '4028478d5da2317c015da2318abd0500', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8020', '4028478d5da2317c015da2318abd0501', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8021', '4028478d5da2317c015da2318abd0502', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8022', '4028478d5da2317c015da2318abd0503', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8023', '4028478d5da2317c015da2318abd0504', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8024', '4028478d5da2317c015da2318abd0600', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8025', '4028478d5da2317c015da2318abd0601', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8026', '4028478d5da2317c015da2318abd0602', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8027', '4028478d5da2317c015da2318abd0603', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8028', '4028478d5da2317c015da2318abd0604', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8029', '4028478d5da2317c015da2318abd0700', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8030', '4028478d5da2317c015da2318abd0701', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8031', '4028478d5da2317c015da2318abd0702', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8032', '4028478d5da2317c015da2318abd0703', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8033', '4028478d5da2317c015da2318abd0704', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8034', '4028478d5da2317c015da2318abd0800', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8035', '4028478d5da2317c015da2318abd0801', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8036', '4028478d5da2317c015da2318abd0802', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8037', '4028478d5da2317c015da2318abd0900', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8038', '4028478d5da2317c015da2318abd0901', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8039', '4028478d5da2317c015da2318abd0902', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8040', '4028478d5da2317c015da2318abd1000', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8041', '4028478d5da2317c015da2318abd1001', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8042', '4028478d5da2317c015da2318abd1002', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8043', '4028478d5da2317c015da2318abd1100', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8044', '4028478d5da2317c015da2318abd1101', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8045', '4028478d5da2317c015da2318abd1102', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8046', '4028478d5da2317c015da2318abd1103', '4028478d5da239d4015da239e20d0000'),
('7fe81ea7835041fd9a6f6b7d83ec8047', '4028478d5da2317c015da2318abd0000', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8048', '4028478d5da2317c015da2318abd0100', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8049', '4028478d5da2317c015da2318abd0101', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8050', '4028478d5da2317c015da2318abd0102', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8051', '4028478d5da2317c015da2318abd0200', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8052', '4028478d5da2317c015da2318abd0201', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8053', '4028478d5da2317c015da2318abd0202', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8054', '4028478d5da2317c015da2318abd0203', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8055', '4028478d5da2317c015da2318abd0204', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8056', '4028478d5da2317c015da2318abd0300', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8057', '4028478d5da2317c015da2318abd0301', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8058', '4028478d5da2317c015da2318abd0302', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8059', '4028478d5da2317c015da2318abd0303', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8060', '4028478d5da2317c015da2318abd0304', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8061', '4028478d5da2317c015da2318abd0400', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8062', '4028478d5da2317c015da2318abd0401', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec806A', '4028478d5da2317c015da2318abd0402', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8063', '4028478d5da2317c015da2318abd0403', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8064', '4028478d5da2317c015da2318abd0404', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8065', '4028478d5da2317c015da2318abd0500', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8066', '4028478d5da2317c015da2318abd0501', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8067', '4028478d5da2317c015da2318abd0502', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec806B', '4028478d5da2317c015da2318abd0503', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8068', '4028478d5da2317c015da2318abd0504', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8069', '4028478d5da2317c015da2318abd0600', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8070', '4028478d5da2317c015da2318abd0601', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8071', '4028478d5da2317c015da2318abd0602', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8072', '4028478d5da2317c015da2318abd0603', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8073', '4028478d5da2317c015da2318abd0604', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8074', '4028478d5da2317c015da2318abd0700', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8075', '4028478d5da2317c015da2318abd0701', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8076', '4028478d5da2317c015da2318abd0702', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8077', '4028478d5da2317c015da2318abd0703', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8078', '4028478d5da2317c015da2318abd0704', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8079', '4028478d5da2317c015da2318abd0800', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8080', '4028478d5da2317c015da2318abd0801', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8081', '4028478d5da2317c015da2318abd0802', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8082', '4028478d5da2317c015da2318abd0900', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8083', '4028478d5da2317c015da2318abd0901', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8084', '4028478d5da2317c015da2318abd0902', '4028478d5da239d4015da239e2230001'),
('7fe81ea7835041fd9a6f6b7d83ec8085', '4028478d5da2317c015da2318abd0000', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8086', '4028478d5da2317c015da2318abd0200', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8087', '4028478d5da2317c015da2318abd0201', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8088', '4028478d5da2317c015da2318abd0202', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8089', '4028478d5da2317c015da2318abd0203', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8090', '4028478d5da2317c015da2318abd0300', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8091', '4028478d5da2317c015da2318abd0301', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8092', '4028478d5da2317c015da2318abd0302', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8093', '4028478d5da2317c015da2318abd0303', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8094', '4028478d5da2317c015da2318abd0402', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8095', '4028478d5da2317c015da2318abd0503', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8096', '4028478d5da2317c015da2318abd0600', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8097', '4028478d5da2317c015da2318abd0601', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8098', '4028478d5da2317c015da2318abd0602', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8099', '4028478d5da2317c015da2318abd0603', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8100', '4028478d5da2317c015da2318abd0604', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8101', '4028478d5da2317c015da2318abd0700', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8102', '4028478d5da2317c015da2318abd0701', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8103', '4028478d5da2317c015da2318abd0702', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8104', '4028478d5da2317c015da2318abd0703', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8105', '4028478d5da2317c015da2318abd0704', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8106', '4028478d5da2317c015da2318abd0800', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8107', '4028478d5da2317c015da2318abd0801', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8108', '4028478d5da2317c015da2318abd0802', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8109', '4028478d5da2317c015da2318abd0900', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8110', '4028478d5da2317c015da2318abd0901', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8111', '4028478d5da2317c015da2318abd0902', '4028478d5da239d4015da239e2230002'),
('7fe81ea7835041fd9a6f6b7d83ec8112', '4028478d5da2317c015da2318abd0000', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8113', '4028478d5da2317c015da2318abd0304', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8114', '4028478d5da2317c015da2318abd0700', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8115', '4028478d5da2317c015da2318abd0701', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8116', '4028478d5da2317c015da2318abd0702', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8117', '4028478d5da2317c015da2318abd0703', '4028478d5da239d4015da239e2230003'),
('7fe81ea7835041fd9a6f6b7d83ec8118', '4028478d5da2317c015da2318abd0704', '4028478d5da239d4015da239e2230003');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

--删除evaluating_ce_record 的evaluatingEarlyMRecordId，childrenCourseId 字段


-- 处理setting 数据。